SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+find +free +dating +sites' IN BOOLEAN MODE)) AND iCityID IN (10243,10801,10932,11097,10908,10778,10551,10579,10218,10498,10581,10389,10242,10617,10303,10556,10831,10580,10784,10611,10530,10746,10438,10300,10397,10689,10249,11048,10214,10964,10923,10944,10771,10259,10773,10343,10229,10216,10534,11084,10484,11011,10766,10267,10336,11000,11093,10604,16249,10361,10868,11133,10770,10368,10401,10200,10697,10867,10426,11130,11083,10733,10954,10395,11108,10680,10455,10896,10780,10679,10706,10640,10504,10790,10967,10976,10723,10693,10302,10382,10905,10342,10569,11091,10769,10179,10299,10402,10971,10437,10669,10567,10807,10515,10568,10392,10852,10410,10393,10781,10677,11120,11052,10333,10234,10629,10851,10676,10648,10409,11006,10941,10633,10789,10543,11059,10280,10824,16225,10588,10772,10396,10228,10823,10739,10202,10926,10391,11102,10747,10270,10695,11035,10782,10900,10704,11099,10220,10809,10384,11031,10909,10461,10899,10290,10808,10650,11103,10536,10388,6894,6980,10627,10974,10477,10507,10203,10406,10860,10467,10204,10914,10709,6888,10442,10169,10481,11116,10476,10915,10912,10185,10940,6867,10942,10398,11090,6946,10913,13030,10904,7007,6986,10468,10621,10469,10540,10804,6949,10779,10793,10636,10665,6984,10736,10458,10447,10661,10209,10752,10655,10997,10783,6966,10400,10578,10585,10213,10664,10215,10872,10972,10853,10854,10522,10445,10542,10651,10873,6850,10478,10788,11013,6925,16128,10618,10226,10541,10423,10668,11033,10597,10496,11042,10519,10497,10628,10928,10227,10495,6901,10643,7019,13034,10979,10499,10605,11124,6932,10881,10863,6995,10281,10372,10379,10919,10911,10297,6955,10224,10630,6900,10631,6945,7010,10681,10526,10920,10555,11010,10194,10662,10574,10219,10987,6889,10625,10953,10436,10548,6952,10319,10462,7004,10413,10755,10879,10584,11112,16119,10357,11015,16152,10837,6886,10836,6897,10599,11131,10191,10895,6972,11026,6872,10408,10882,10334,10785,10217,16186,11109,6934,10407,10563,13033,10933,10450,11032,10825,10877,10261,10890,10980,10734,10347,10725,16150,10266,10381,11027,10830,11122,10943,11043,11053,10528,10265,10189,13027,10508,10420,10698,11123,10583,10570,10433,11040,6965,10479,10225,7017,10222,10394,10404,10358,10996,10981,11126,10745,10449,10187,10726,10870,10897,11071,11022,10691,10424,10675,10603,11034,10286,16156,10502,10729,10898,10276,11014,6903,10724,11134,10533,6941,10192,10991,10233,10271,10529,10575,11004,10369,11065,10308,16113,10797,10858,6971,10383,10523,10577,10652,10731,10505,11113,10254,10444,10223,11009,16157,10903,6919,13028,16112,10268,9877,10961,10666,9802,6904,10443,6944,10593,9894,16233,10947,9872,10253,10949,10948,10118,10596,13016,9876,16144,9856,10506,10405,10922,9846,10535,6953,10847,10493,9962,10984,10829,10258,9859,10316,10269,9884,9850,10032,9908,10019,10483,13038,6863,10759,11008,10062,16588,10020,10013,10145,10247,10978,10140,9816,10799,10231,10818,9917,10125,9862,10815,9920,16589,10063,10833,10338,10116,10378,10212,9932,11036,9823,10240,10008,10028,9967,9996,11136,9909,10452,10088,10067,6979,16164,10639,10794,10066,6930,9875,10539,16165,6997,10029,6908) ORDER BY FIELD(iCityID, 10243,10801,10932,11097,10908,10778,10551,10579,10218,10498,10581,10389,10242,10617,10303,10556,10831,10580,10784,10611,10530,10746,10438,10300,10397,10689,10249,11048,10214,10964,10923,10944,10771,10259,10773,10343,10229,10216,10534,11084,10484,11011,10766,10267,10336,11000,11093,10604,16249,10361,10868,11133,10770,10368,10401,10200,10697,10867,10426,11130,11083,10733,10954,10395,11108,10680,10455,10896,10780,10679,10706,10640,10504,10790,10967,10976,10723,10693,10302,10382,10905,10342,10569,11091,10769,10179,10299,10402,10971,10437,10669,10567,10807,10515,10568,10392,10852,10410,10393,10781,10677,11120,11052,10333,10234,10629,10851,10676,10648,10409,11006,10941,10633,10789,10543,11059,10280,10824,16225,10588,10772,10396,10228,10823,10739,10202,10926,10391,11102,10747,10270,10695,11035,10782,10900,10704,11099,10220,10809,10384,11031,10909,10461,10899,10290,10808,10650,11103,10536,10388,6894,6980,10627,10974,10477,10507,10203,10406,10860,10467,10204,10914,10709,6888,10442,10169,10481,11116,10476,10915,10912,10185,10940,6867,10942,10398,11090,6946,10913,13030,10904,7007,6986,10468,10621,10469,10540,10804,6949,10779,10793,10636,10665,6984,10736,10458,10447,10661,10209,10752,10655,10997,10783,6966,10400,10578,10585,10213,10664,10215,10872,10972,10853,10854,10522,10445,10542,10651,10873,6850,10478,10788,11013,6925,16128,10618,10226,10541,10423,10668,11033,10597,10496,11042,10519,10497,10628,10928,10227,10495,6901,10643,7019,13034,10979,10499,10605,11124,6932,10881,10863,6995,10281,10372,10379,10919,10911,10297,6955,10224,10630,6900,10631,6945,7010,10681,10526,10920,10555,11010,10194,10662,10574,10219,10987,6889,10625,10953,10436,10548,6952,10319,10462,7004,10413,10755,10879,10584,11112,16119,10357,11015,16152,10837,6886,10836,6897,10599,11131,10191,10895,6972,11026,6872,10408,10882,10334,10785,10217,16186,11109,6934,10407,10563,13033,10933,10450,11032,10825,10877,10261,10890,10980,10734,10347,10725,16150,10266,10381,11027,10830,11122,10943,11043,11053,10528,10265,10189,13027,10508,10420,10698,11123,10583,10570,10433,11040,6965,10479,10225,7017,10222,10394,10404,10358,10996,10981,11126,10745,10449,10187,10726,10870,10897,11071,11022,10691,10424,10675,10603,11034,10286,16156,10502,10729,10898,10276,11014,6903,10724,11134,10533,6941,10192,10991,10233,10271,10529,10575,11004,10369,11065,10308,16113,10797,10858,6971,10383,10523,10577,10652,10731,10505,11113,10254,10444,10223,11009,16157,10903,6919,13028,16112,10268,9877,10961,10666,9802,6904,10443,6944,10593,9894,16233,10947,9872,10253,10949,10948,10118,10596,13016,9876,16144,9856,10506,10405,10922,9846,10535,6953,10847,10493,9962,10984,10829,10258,9859,10316,10269,9884,9850,10032,9908,10019,10483,13038,6863,10759,11008,10062,16588,10020,10013,10145,10247,10978,10140,9816,10799,10231,10818,9917,10125,9862,10815,9920,16589,10063,10833,10338,10116,10378,10212,9932,11036,9823,10240,10008,10028,9967,9996,11136,9909,10452,10088,10067,6979,16164,10639,10794,10066,6930,9875,10539,16165,6997,10029,6908) ASC, p.tmPosted DESC LIMIT 24